French translation CSV exports


In [ ]:
%run "../Functions/0.1 GF English localization.ipynb"

Translation of all possible answers

Possible answers


In [ ]:
# The first translated element is the correct answer when applicable
# Options that are deprecated are listed last

interestPossibleAnswersFR = [\
	"Pas du tout",
	"Un peu",
	"Moyennement",
	"Beaucoup",
	"Énormément",
	]
        
everPlayedPossibleAnswersFR = [\
    "Je viens d'y jouer pour la première fois",
    "J'y ai joué plusieurs fois récemment sur cet ordinateur",
    "J'y ai joué récemment sur un autre ordinateur",
    "J'y ai joué il y a un moment",
    "Non / pas encore",
    
    # deprecated
    "J'y ai joué plusieurs fois récemment",
    ]

genderPossibleAnswersFR = [\
	"Femme",
	"Homme",
	"Autre",
	"Je ne souhaite pas le préciser",
    ]

biologyStudyPossibleAnswersFR = [\
	"Jamais, pas même au collège",
	"Jusqu'au brevet",
	"Jusqu'au bac",
	"Jusqu'à la license",
	"Au moins jusqu'au master",
	]

frequencyPossibleAnswersFR = [\
	"Pas du tout",
	"Un peu",
	"Moyennement",
	"Beaucoup",
	"Énormément",
	]

heardAboutBioBricksPossibleAnswersFR = [\
    "Non",
    "Oui, mais je ne sais pas exactement ce que c'est",
    "Oui, et je sais ce que c'est",
	]

yesNoPossibleAnswersFR = [\
	"Oui",
	"Non",
	]

enjoyedTheGamePossibleAnswersFR = [\
    "Ne s'applique pas : pas encore joué",
    "Pas du tout",
    "Un peu",
    "Moyennement",
    "Beaucoup",
    "Extrêmement",
    ]

#Q16PossibleAnswers
QGenotypePhenotypePossibleAnswersFR = [\
	"Modifier l'ADN de la bactérie",
	"Ramasser des nanorobots",
	"Faire bouger la bactérie",
	"Diviser la bactérie",
	"Je ne sais pas",
	]

#Q17PossibleAnswers
QBioBricksDevicesCompositionPossibleAnswersFR = [\
	"Des séquences d'ARN",
	"Des acides aminés",
	"Des protéines",
	"Des séquences d'ADN",
	"Je ne sais pas",
	]

#Q18PossibleAnswers
QAmpicillinPossibleAnswersFR = [\
	"Ampicilline",
	"Arabinose",
	"GFP",
	"Terminateur",
	"Je ne sais pas",
	]

BioBrickAnswersPossibleAnswersFR = [\
	"Aucun de ces éléments",
	"1",
	"2",
	"3",
	"4",
	"5",
	"Je ne sais pas",
	]

DeviceAnswersPossibleAnswersFR = [\
	"Les briques ne sont pas dans le bon ordre",
	"Elle produit la fluorescence verte",
	"Elle produit la fluorescence verte en présence d'inducteur arabinose",
	"Elle permet de se déplacer plus vite",
	"Elle permet de résister aux antibiotiques",
	"Je ne sais pas",
	]

#Q40PossibleAnswers
QGreenFluorescencePossibleAnswersFR = [\
	"Sous lumière bleue, quand la construction GFP est équipée",
	"Sous lumière bleue, tout le temps",
	"Devant les portes, quand la construction GFP est équipée",
	"Devant les portes, tout le temps",
	"Je ne sais pas",
	]

#Q41PossibleAnswers
QUnequipDevicePossibleAnswersFR = [\
	"La bactérie devient lumineuse",
	"La bactérie meurt",
	"Les flagelles disparaissent l'un après l'autre, rapidement",
	"Rien",
	"Je ne sais pas",
	]

#Q42PossibleAnswers
QDevicePbadRbsAraTerPossibleAnswersFR = [\
	"Elle produit de l'arabinose tout le temps.",
	"Elle n'est active que dans les nuages d'arabinose.",
	"Elle produit de plus en plus d'arabinose après avoir été induite, puisqu'elle s'induit elle-même.",
	"Elle ne produit rien puisqu'elle s'induit elle-même",
	"Je ne sais pas",
	]

Assembly of all possible answers


In [ ]:
possibleAnswersFR = pd.Series(
    [
# Timestamp
    #'Timestamp', #01
        [],

# Basic engagement questions
    #'Are you interested in learning more about...Biology', #02
        interestPossibleAnswersFR,
    #'Are you interested in learning more about...Synthetic biology', #03
        interestPossibleAnswersFR,
    #'Are you interested in learning more about...Video games', #04
        interestPossibleAnswersFR,
    #'Are you interested in learning more about...Engineering', #05
        interestPossibleAnswersFR,

# Experience with Hero.Coli
    #'Have you ever played Hero.Coli?', #06
        everPlayedPossibleAnswersFR,

# Basic demographics questions
    #'How old are you?', #07
        [],
    #'What is your gender?', #08
        genderPossibleAnswersFR,
    #'Are you interested in video games?', #09
        interestPossibleAnswersFR,
    #'Are you interested in biology?', #10
        interestPossibleAnswersFR,
    #'How long have you studied biology?', #11
        biologyStudyPossibleAnswersFR,
    #'Do you play video games?', #12
        frequencyPossibleAnswersFR,

# Basic biology questions
    #'Have you ever heard about synthetic biology or BioBricks, outside of Hero.Coli?', #13
        heardAboutBioBricksPossibleAnswersFR,

# Basic engagement questions
    #'Do you volunteer to contribute to our study by answering 9 more questions? (5 min)', #14
        yesNoPossibleAnswersFR,
    #'Did you enjoy playing the game?', #15
        enjoyedTheGamePossibleAnswersFR,

# General mechanics of the game
    #'In order to modify the abilities of the bacterium, you have to...', #16
        QGenotypePhenotypePossibleAnswersFR,
    #'What are BioBricks and devices?', #17
        QBioBricksDevicesCompositionPossibleAnswersFR,
    #'Find the antibiotic:', #18
        QAmpicillinPossibleAnswersFR,

# BioBrick names and functions
    #'Plasmid is...', #19
        BioBrickAnswersPossibleAnswersFR,
    #'Represents the end of a device... TER', #20
        BioBrickAnswersPossibleAnswersFR,
    #'Promoter is...', #21
        BioBrickAnswersPossibleAnswersFR,
    #'Represents the ability given... CDS', #22
        BioBrickAnswersPossibleAnswersFR,
    #'Terminator is...', #23
        BioBrickAnswersPossibleAnswersFR,
    #'Codes a protein... CDS', #24
        BioBrickAnswersPossibleAnswersFR,
    #'RBS is...', #25
        BioBrickAnswersPossibleAnswersFR,
    #'Can represent GFP... CDS', #26
        BioBrickAnswersPossibleAnswersFR,
    #'Coding Sequence is...', #27
        BioBrickAnswersPossibleAnswersFR,
    #'Controls when the device is active... PR', #28
        BioBrickAnswersPossibleAnswersFR,
    #'Controls the level of expression, and thus how much the ability will be affected... RBS', #29
        BioBrickAnswersPossibleAnswersFR,
    #'Makes it possible to equip an additional device. Plasmid', #30
        BioBrickAnswersPossibleAnswersFR,
    #'Operator is... XXX', #31
        BioBrickAnswersPossibleAnswersFR,

# Device symbols
    #'What does this device do? RBS:PCONS:FLHDC:TER XXX', #32
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? PCONS:RBS:FLHDC:TER', #33
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? PBAD:RBS:GFP:TER', #34
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? PBAD:GFP:RBS:TER XXX', #35
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? GFP:RBS:PCONS:TER XXX', #36
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? PCONS:GFP:RBS:TER XXX', #37
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? AMPR:RBS:PCONS:TER XXX', #38
        DeviceAnswersPossibleAnswersFR,
    #'What does this device do? RBS:PCONS:AMPR:TER XXX', #39
        DeviceAnswersPossibleAnswersFR,

# Beyond the game
    #'When does green fluorescence happen?', #40
        QGreenFluorescencePossibleAnswersFR,
    #'What happens when you unequip the movement device?', #41
        QUnequipDevicePossibleAnswersFR,
    #'Last question. Next page only contains remarks.Guess: you have crafted a functional device containing an arabinose-induced promoter and an arabinose Coding Sequence (CDS). What will happen?', #42
        QDevicePbadRbsAraTerPossibleAnswersFR,

# Remarks
    #'You can write down remarks here.', #43
        [],

# Technical data
    #'userId', #44
        [],
    #'Language', #45
        languagePossibleAnswers,
    #'Temporality' #46
        temporalityPossibleAnswers,

    ], index = gformColumns
)
#possibleAnswersFR

Dictionaries


In [ ]:
interestTranslation = dict(zip(interestPossibleAnswersFR, interestPossibleAnswersEN))
everPlayedTranslation = dict(zip(everPlayedPossibleAnswersFR, everPlayedPossibleAnswersEN))
genderTranslation = dict(zip(genderPossibleAnswersFR, genderPossibleAnswersEN))
biologyStudyTranslation = dict(zip(biologyStudyPossibleAnswersFR, biologyStudyPossibleAnswersEN))
frequencyTranslation = dict(zip(frequencyPossibleAnswersFR, frequencyPossibleAnswersEN))
heardAboutBioBricksTranslation = dict(zip(heardAboutBioBricksPossibleAnswersFR, heardAboutBioBricksPossibleAnswersEN))
yesNoTranslation = dict(zip(yesNoPossibleAnswersFR, yesNoPossibleAnswersEN))
enjoyedTheGameTranslation = dict(zip(enjoyedTheGamePossibleAnswersFR, enjoyedTheGamePossibleAnswersEN))
QGenotypePhenotypeTranslation = dict(zip(QGenotypePhenotypePossibleAnswersFR, QGenotypePhenotypePossibleAnswersEN))
QBioBricksDevicesCompositionTranslation = dict(zip(QBioBricksDevicesCompositionPossibleAnswersFR, QBioBricksDevicesCompositionPossibleAnswersEN))
QAmpicillinTranslation = dict(zip(QAmpicillinPossibleAnswersFR, QAmpicillinPossibleAnswersEN))
BioBrickAnswersTranslation = dict(zip(BioBrickAnswersPossibleAnswersFR, BioBrickAnswersPossibleAnswersEN))
DeviceAnswersTranslation = dict(zip(DeviceAnswersPossibleAnswersFR, DeviceAnswersPossibleAnswersEN))
QGreenFluorescenceTranslation = dict(zip(QGreenFluorescencePossibleAnswersFR, QGreenFluorescencePossibleAnswersEN))
QUnequipDeviceTranslation = dict(zip(QUnequipDevicePossibleAnswersFR, QUnequipDevicePossibleAnswersEN))
QDevicePbadRbsAraTerTranslation = dict(zip(QDevicePbadRbsAraTerPossibleAnswersFR, QDevicePbadRbsAraTerPossibleAnswersEN))

Translation


In [ ]:
questionsAnswersTranslationsFR = pd.Series(
    [
            
# Timestamp
        #'Timestamp', #01
            [],

# Basic engagement questions
        #'Are you interested in learning more about...Biology', #02
            interestTranslation,
        #'Are you interested in learning more about...Synthetic biology', #03
            interestTranslation,
        #'Are you interested in learning more about...Video games', #04
            interestTranslation,
        #'Are you interested in learning more about...Engineering', #05
            interestTranslation,

# Experience with Hero.Coli
        #'Have you ever played Hero.Coli?', #06
            everPlayedTranslation,

# Basic demographics questions
        #'How old are you?', #07
            [],
        #'What is your gender?', #08
            genderTranslation,
        #'Are you interested in video games?', #09
            interestTranslation,
        #'Are you interested in biology?', #10
            interestTranslation,
        #'How long have you studied biology?', #11
            biologyStudyTranslation,
        #'Do you play video games?', #12
            frequencyTranslation,

# Basic biology questions
        #'Have you ever heard about synthetic biology or BioBricks, outside of Hero.Coli?', #13
            heardAboutBioBricksTranslation,

# Basic engagement questions
        #'Do you volunteer to contribute to our study by answering 9 more questions? (5 min)', #14
            yesNoTranslation,
        #'Did you enjoy playing the game?', #15
            enjoyedTheGameTranslation,

# General mechanics of the game
        #'In order to modify the abilities of the bacterium, you have to...', #16
            QGenotypePhenotypeTranslation,
        #'What are BioBricks and devices?', #17
            QBioBricksDevicesCompositionTranslation,
        #'Find the antibiotic:', #18
            QAmpicillinTranslation,

# BioBrick names and functions
        #'Plasmid is...', #19
            BioBrickAnswersTranslation,
        #'Represents the end of a device... TER', #20
            BioBrickAnswersTranslation,
        #'Promoter is...', #21
            BioBrickAnswersTranslation,
        #'Represents the ability given... CDS', #22
            BioBrickAnswersTranslation,
        #'Terminator is...', #23
            BioBrickAnswersTranslation,
        #'Codes a protein... CDS', #24
            BioBrickAnswersTranslation,
        #'RBS is...', #25
            BioBrickAnswersTranslation,
        #'Can represent GFP... CDS', #26
            BioBrickAnswersTranslation,
        #'Coding Sequence is...', #27
            BioBrickAnswersTranslation,
        #'Controls when the device is active... PR', #28
            BioBrickAnswersTranslation,
        #'Controls the level of expression, and thus how much the ability will be affected... RBS', #29
            BioBrickAnswersTranslation,
        #'Makes it possible to equip an additional device. Plasmid', #30
            BioBrickAnswersTranslation,
        #'Operator is... XXX', #31
            BioBrickAnswersTranslation,

# Device symbols
        #'What does this device do? RBS:PCONS:FLHDC:TER XXX', #32
            DeviceAnswersTranslation,
        #'What does this device do? PCONS:RBS:FLHDC:TER', #33
            DeviceAnswersTranslation,
        #'What does this device do? PBAD:RBS:GFP:TER', #34
            DeviceAnswersTranslation,
        #'What does this device do? PBAD:GFP:RBS:TER XXX', #35
            DeviceAnswersTranslation,
        #'What does this device do? GFP:RBS:PCONS:TER XXX', #36
            DeviceAnswersTranslation,
        #'What does this device do? PCONS:GFP:RBS:TER XXX', #37
            DeviceAnswersTranslation,
        #'What does this device do? AMPR:RBS:PCONS:TER XXX', #38
            DeviceAnswersTranslation,
        #'What does this device do? RBS:PCONS:AMPR:TER XXX', #39
            DeviceAnswersTranslation,

# Beyond the game
        #'When does green fluorescence happen?', #40
            QGreenFluorescenceTranslation,
        #'What happens when you unequip the movement device?', #41
            QUnequipDeviceTranslation,
        #'Last question. Next page only contains remarks.Guess: you have crafted a functional device containing an arabinose-induced promoter and an arabinose Coding Sequence (CDS). What will happen?', #42
            QDevicePbadRbsAraTerTranslation,

# Remarks
        #'You can write down remarks here.', #43
            [],

# Technical data
        #'userId', #44
            [],
        #'Language', #45
            [],
        #'Temporality' #46
            [],
            
        ], index = gformEN1522.columns
)
#questionsAnswersTranslationsFR
#questionsAnswersTranslationsFR.loc['Are you interested in video games?']['Beaucoup']

In [ ]:
#questionsAnswersTranslationsFR

Export


In [ ]:
#questionsAnswersTranslationsFR.to_csv(frTranslationsPath, encoding=csvEncoding)

Deprecated: demographic and scientific 'correct' answers


In [ ]:
#demographicAnswersFR
#correctAnswersFR

In [ ]:
#demographicAnswersFR.to_csv(frDemographicAnswersPath, encoding=csvEncoding)
#correctAnswersFR.to_csv(frCorrectScientificAnswersPath, encoding=csvEncoding)